/*
 * 
 */
package w83a.w83aDAO;

import java.util.ArrayList;
import java.util.List;

import w83a.util.jdbc.W83aDataBase;
import w83a.w83aBeans.W83aSindicatosBean;
import w83a.w83aUtilidadesComunes.W83aClsConstantes;

// TODO: Auto-generated Javadoc
/**
 * The Interface W83aISindicatosDAO.
 * @author a
 */
public class W83aSindicatosDAO implements W83aISindicatosDAO{
	
	public List obtenerSindicatosPreaviso(String sindicatosPreaviso) throws Exception{
		StringBuffer strSql = new StringBuffer(W83aClsConstantes.CUARENTA);
		List params = new ArrayList();
		strSql.append("SELECT C_SINDI_019 ,DESC_019, SIGLAS_019, CVERIF_019, CMADRID_019, RELSTES_019, DESE_019, " +
				"F_BAJA_019, DIR_SINDI_019, PROV_SINDI_019, MUN_SINDI_019, CODPOS_019 FROM W83B19S00 WHERE C_SINDI_019 IN(");
		strSql.append(sindicatosPreaviso);
		strSql.append(")");
		
		
		return W83aDataBase.executeQuery(strSql.toString(),params,W83aSindicatosBean.class,null, null);
	}
	
	

}